UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oHkFqE/nw44DCfUhyF1MQxo/yo2OsWVmSa+SYBUm1Wo='
WHERE
key_id = 'af6d4aee5376ed07a6a7010219c85d50e4f428ae0e90016b3273fcf8df58a259'
AND (
token = 'oHkFqE/nw44DCfUhyF1MQxo/yo2OsWVmSa+SYBUm1Wo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)