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