UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NG1xtYPvEFs86GNg9UXl8kCkJUwZt7yPHh7kk7yoZEI='
WHERE
key_id = '99d12fc6ba24e158e80118967b9f8d86a6d42193dd81eca930a6cc9144cbea75'
AND (
token = 'NG1xtYPvEFs86GNg9UXl8kCkJUwZt7yPHh7kk7yoZEI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)