UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cWXD6Fiz0vnC53VfmCThA8dcmJEjHtXpaYLFjSNJjOQ='
WHERE
key_id = '54724feb03a062f81f2c78f55f117888c733edfb24338f5a9c114b55815679ab'
AND (
token = 'cWXD6Fiz0vnC53VfmCThA8dcmJEjHtXpaYLFjSNJjOQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)