UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AvtAPa5ee16CWECocdqe2CDa2xU2ilDP2zruqLgZe44='
WHERE
key_id = '8bc144da4aac86d50a39c0a46cdb4ac31be52dcf253968a79c38d18442d6771d'
AND (
token = 'AvtAPa5ee16CWECocdqe2CDa2xU2ilDP2zruqLgZe44='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)