UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qIgvwhXhkMj2auIxjC4nhJp0HeWAzd+hugJ8UrSHoi8='
WHERE
key_id = '18949a58b3f009fbf10951d8c8ac602a8aba61efa0b82650f82d951c4dc26f08'
AND (
token = 'qIgvwhXhkMj2auIxjC4nhJp0HeWAzd+hugJ8UrSHoi8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)