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