UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zTJxvAd5sfpPhjw+vMy1qHf/+Hi4Y2+M9isYJV7hc40='
WHERE
key_id = '81c42f5f4542adf91c7026db728999c3154a1c9a274c96309e984fbbf0872e98'
AND (
token = 'zTJxvAd5sfpPhjw+vMy1qHf/+Hi4Y2+M9isYJV7hc40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)