UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WctOkEbbhwzBC6mW8enLl2efS10yXv5shAqhKtsRegI='
WHERE
key_id = '6c973ff8a273503fb1518be67fed30982516b29b655fed99e8bb9db86046f2a2'
AND (
token = 'WctOkEbbhwzBC6mW8enLl2efS10yXv5shAqhKtsRegI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)