UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XNBNaiFYKIvu1eDgAdDeCLah4g2bp9yV96HsNdJyCPI='
WHERE
key_id = '626de39cc9432bc9b94e830abb2f1c29c1d97f7b9e6f5e00260d3a8695530cf5'
AND (
token = 'XNBNaiFYKIvu1eDgAdDeCLah4g2bp9yV96HsNdJyCPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)