UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U4YnJIU1HRBznQhLSgF01b7nCnHFpwuC44tSBUju+bU='
WHERE
key_id = 'b6920c3667c8bc494f24d82cd08992b03a4147d9d31af8cd8d2e8956c4e0f6c1'
AND (
token = 'U4YnJIU1HRBznQhLSgF01b7nCnHFpwuC44tSBUju+bU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)