UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '25E7OSTR64rwtc/bpnlj2ncJNMD4L6NTP8MAUF18eW8='
WHERE
key_id = '8ca34d5432fec7088e03f1a06762e87064cecd6072a1a96e89fa11efd2211407'
AND (
token = '25E7OSTR64rwtc/bpnlj2ncJNMD4L6NTP8MAUF18eW8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)