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