UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qxSQ+EMNHD0toqVxPui2Wq35A2NrrJ5W5fRXnK4jB+o='
WHERE
key_id = 'f20ec81c46d2f6d8bf8aa90c81eb1febc0063f61f427dba589ed73b880912420'
AND (
token = 'qxSQ+EMNHD0toqVxPui2Wq35A2NrrJ5W5fRXnK4jB+o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)