UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4lh2SLNFBY7K6d7JTGphrKlW1lHg6d1bOY3iY4KMAcA='
WHERE
key_id = '5933f0640ccda690631d7761438240473125b2c930a7ca21bba5f3fff9ded95a'
AND (
token = '4lh2SLNFBY7K6d7JTGphrKlW1lHg6d1bOY3iY4KMAcA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)