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