UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TZI+nHrAgKs5Y+z364LOkYabsG+xVbVxMeLm/fTfrW8='
WHERE
key_id = '938e3552c9c54c8c0b2674d0bd42676c2f935ea806e0889241644a340a67ccae'
AND (
token = 'TZI+nHrAgKs5Y+z364LOkYabsG+xVbVxMeLm/fTfrW8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)