UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dJ5zry5fK1Ka0RHn3fjdJKF7vSvSsnbTbl/QmG/TJzU='
WHERE
key_id = 'e1f71a4d36bef1b223c68648a9a20c264b357a42b8c36bfd6bf4ea784ac6ccff'
AND (
token = 'dJ5zry5fK1Ka0RHn3fjdJKF7vSvSsnbTbl/QmG/TJzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)