UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ESK/fbopjt6WvcykY8zkhkYWL+d8qfykDLbFiYe76pA='
WHERE
key_id = '0165175eed9d1549ae6fd019b3ce2773cbfc862712f5436078d9b30257902fcf'
AND (
token = 'ESK/fbopjt6WvcykY8zkhkYWL+d8qfykDLbFiYe76pA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)