UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gPjHvqNu+OpgNgFQg6k0PLOA1D2BIW49kOtA9xgJq24='
WHERE
key_id = '9f7280ab87b2d25904ba7cc36bc8defef042c036d467008f354f57b2806490b8'
AND (
token = 'gPjHvqNu+OpgNgFQg6k0PLOA1D2BIW49kOtA9xgJq24='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)