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