UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3uwQxmMhPEGtfYkJzzhrsEdWhKEEhZlS7mZf2twfFFU='
WHERE
key_id = '7a107d92bd6c49322505a33de330641b8cf326109987cd8b392dee1c163445d3'
AND (
token = '3uwQxmMhPEGtfYkJzzhrsEdWhKEEhZlS7mZf2twfFFU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)