UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3hS0OPWA61X1dmDsiYNxpaHlJDy2iUFvOUsM1jX/Pz8='
WHERE
key_id = 'be520a6774431d657e500e19d45919cddf463c677511ea891ab0f9e7c1c2725e'
AND (
token = '3hS0OPWA61X1dmDsiYNxpaHlJDy2iUFvOUsM1jX/Pz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)