UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cOqNkqhret9cFb0P0AqVOI3nyiZdSPEe68tyhTuCDSA='
WHERE
key_id = '5e8aa8ee7ecfba5c765695928eb254ec1903f6f786f6430f967fdd136cbdf798'
AND (
token = 'cOqNkqhret9cFb0P0AqVOI3nyiZdSPEe68tyhTuCDSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)