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