UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BuWJ/NNt6eVEOXFYPR5Wh3qEsL5yaoGVtp9DogjHVcs='
WHERE
key_id = 'd529a83e6989af23713abf09a789a0a938fcc277d689a760a502e0aef6aac2e5'
AND (
token = 'BuWJ/NNt6eVEOXFYPR5Wh3qEsL5yaoGVtp9DogjHVcs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)