UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rNIp74lNbkME7jw5kXzYdmYc2qN2+5bAszz7RrLx0x4='
WHERE
key_id = '371731c70e971224d9dff8a0677d5f0d68981639180bcf71624f832ab587b23f'
AND (
token = 'rNIp74lNbkME7jw5kXzYdmYc2qN2+5bAszz7RrLx0x4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)