UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W1irxQwZHKTPku8ct/ssZ8r5nPl0l50kurP+czgtd4Q='
WHERE
key_id = 'edab7268ca1e95e79899eeec2d344ba0472f100170f5acf537209eef8b6fa07b'
AND (
token = 'W1irxQwZHKTPku8ct/ssZ8r5nPl0l50kurP+czgtd4Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)