UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CJp8eFRcUUvWqKrPlVj6m4kUUC4zr3Yk7J0GRkB0LAI='
WHERE
key_id = '1e96b69ee2f88585275d672fdf0d8bc2012518eb0cca1990aca01c186d35fd4b'
AND (
token = 'CJp8eFRcUUvWqKrPlVj6m4kUUC4zr3Yk7J0GRkB0LAI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)