UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gf0j+Czb7to00yy1wVtjvclh3IcGgfVBJOWJ/qncrM4='
WHERE
key_id = 'dd9683224f73f1e14545b4c5a84a039fbb5ef22066a066f22e2e1e9282ae5cbf'
AND (
token = 'gf0j+Czb7to00yy1wVtjvclh3IcGgfVBJOWJ/qncrM4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)