UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7iUt23RQZHBwNs8oL+bJwb8DCJ2obVem/A/zEkRSwD8='
WHERE
key_id = '519fbd314261e8cf483e6d82ea208e271b6ad67679e7c552326f2e3b43e13912'
AND (
token = '7iUt23RQZHBwNs8oL+bJwb8DCJ2obVem/A/zEkRSwD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)