UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sJrpOoOmcjthW9DqxeRmAQfBf/FP7zjwQSkaKPKYudg='
WHERE
key_id = '8a9d178707f126f4c1c887ce7edf55929cbbb525aa80441fd57c6516c86052b0'
AND (
token = 'sJrpOoOmcjthW9DqxeRmAQfBf/FP7zjwQSkaKPKYudg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)