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