UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dhliXLo4QjbQdz5b60c9XvrcypQUni/3l0j8WldOwM4='
WHERE
key_id = 'd47cdae1322a236fcc2bf8f1e0922a4c6b5399575d5b290210dda16c7cfc1d2b'
AND (
token = 'dhliXLo4QjbQdz5b60c9XvrcypQUni/3l0j8WldOwM4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)