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