UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4NV47TVGoNoZBqz35i1kzkvS4EcMxN7BK9jaMWdQk4w='
WHERE
key_id = 'e1910844b68ba5a3c59d59e2ae82ee0315684fb6029c0cfabe7d2c0e5f8b05fa'
AND (
token = '4NV47TVGoNoZBqz35i1kzkvS4EcMxN7BK9jaMWdQk4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)