UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tstp7N3hIPMPiYSg2RTepAj1OnLwftNo0jNMAEkEYWY='
WHERE
key_id = '2ef27c8718b82c55ddd1864a37b2255eddfefb8701471005ec56d9fae08a34e0'
AND (
token = 'tstp7N3hIPMPiYSg2RTepAj1OnLwftNo0jNMAEkEYWY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)