UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XGMefwJ0lvVZGSwGnjjx2ZHhWaA6n4FrpynlKyUCcrU='
WHERE
key_id = '76ac3f22e4bb91df4257d4f4e2e04349188b4ae8ac49152edb23976409ce7121'
AND (
token = 'XGMefwJ0lvVZGSwGnjjx2ZHhWaA6n4FrpynlKyUCcrU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)