UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6jDuYylw+KO02hhIPhiV0XoxF/hgvrHxNjnHz4sX8vw='
WHERE
key_id = '189795249c76bf0fa2768cd1b65ba74b88d6fc492dda350abd17addb77166bec'
AND (
token = '6jDuYylw+KO02hhIPhiV0XoxF/hgvrHxNjnHz4sX8vw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)