UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8fCqKJ3yMnroie8kA/MFiho8lbrEXNG4DLpOEqBYPYY='
WHERE
key_id = 'd83fdaf7f77012af823e15c042e51942a38277b33d6dffc5408422b7afe7e146'
AND (
token = '8fCqKJ3yMnroie8kA/MFiho8lbrEXNG4DLpOEqBYPYY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)