UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cc1AFy1nTX26g6TTkDAreI5+4/KCW78QlPI5nfSlZP4='
WHERE
key_id = 'f5107525eb9ccaa41a1905d66a1821ab630da9325e0486064a9f82f4863ea69c'
AND (
token = 'cc1AFy1nTX26g6TTkDAreI5+4/KCW78QlPI5nfSlZP4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)