UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fX7b89xICmDbnEFNU4OfIHs1CUqnHj6yw4GMLcumwTU='
WHERE
key_id = '2eb6b4c4e088ea3c7e89a18cb8b917f26c0fe44090677f595969e2dec375564b'
AND (
token = 'fX7b89xICmDbnEFNU4OfIHs1CUqnHj6yw4GMLcumwTU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)