UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CRye7h+WOZ1tmue1zhTZZSOxz0AVQS7wTQmj/eK3K9M='
WHERE
key_id = '7c1aac19d40f2cea642cda803361e9505a5a34d0975cfeb1282a8b1ebd9cc242'
AND (
token = 'CRye7h+WOZ1tmue1zhTZZSOxz0AVQS7wTQmj/eK3K9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)