UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dlCTTJFGzjbHFi2XpjqsELuU5Qo4z8YcF0T7C++DCDk='
WHERE
key_id = '4b140260b44c0572e1a16f54363f61af68e7f1f74bc235001f38ffdb9307f56c'
AND (
token = 'dlCTTJFGzjbHFi2XpjqsELuU5Qo4z8YcF0T7C++DCDk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)