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