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