UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DreAkK2qCsyj89AE3fmWmRZRFqH3AY0K2msE4HV20CA='
WHERE
key_id = 'a55f0a1a01a4bf9f8561c1f9433c149cb09a800fe211d3dc8d88ef07c186cb12'
AND (
token = 'DreAkK2qCsyj89AE3fmWmRZRFqH3AY0K2msE4HV20CA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)